Tabela OrgUnitHierarchyExport

Definicja tabeli OrgUnitHierarchyExport

Name

OrgUnitHierarchyExport

Code

OrgUnitHierarchyExport

Comment

 


Lista kolumn tabeli OrgUnitHierarchyExport

Name

Code

ID

ID

OrgUnitHierarchyExportID

OrgUnitHierarchyExportID

StartDT

StartDT

StopDT

StopDT

BedsID_1

BedsID_1

BedsID_2

BedsID_2

BedsID_3

BedsID_3

BedsID_4

BedsID_4

BedsID_5

BedsID_5

BedsID_6

BedsID_6

InsertDate

InsertDate

StatusID

StatusID


Kolumna ID tabeli OrgUnitHierarchyExport

Definicja kolumny ID tabeli OrgUnitHierarchyExport

Name

ID

Code

ID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna OrgUnitHierarchyExportID tabeli OrgUnitHierarchyExport

Definicja kolumny OrgUnitHierarchyExportID tabeli OrgUnitHierarchyExport

Name

OrgUnitHierarchyExportID

Code

OrgUnitHierarchyExportID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli OrgUnitHierarchyExport

Definicja kolumny StartDT tabeli OrgUnitHierarchyExport

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli OrgUnitHierarchyExport

Definicja kolumny StopDT tabeli OrgUnitHierarchyExport

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna BedsID_1 tabeli OrgUnitHierarchyExport

Definicja kolumny BedsID_1 tabeli OrgUnitHierarchyExport

Name

BedsID_1

Code

BedsID_1

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BedsID_2 tabeli OrgUnitHierarchyExport

Definicja kolumny BedsID_2 tabeli OrgUnitHierarchyExport

Name

BedsID_2

Code

BedsID_2

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BedsID_3 tabeli OrgUnitHierarchyExport

Definicja kolumny BedsID_3 tabeli OrgUnitHierarchyExport

Name

BedsID_3

Code

BedsID_3

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BedsID_4 tabeli OrgUnitHierarchyExport

Definicja kolumny BedsID_4 tabeli OrgUnitHierarchyExport

Name

BedsID_4

Code

BedsID_4

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BedsID_5 tabeli OrgUnitHierarchyExport

Definicja kolumny BedsID_5 tabeli OrgUnitHierarchyExport

Name

BedsID_5

Code

BedsID_5

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BedsID_6 tabeli OrgUnitHierarchyExport

Definicja kolumny BedsID_6 tabeli OrgUnitHierarchyExport

Name

BedsID_6

Code

BedsID_6

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InsertDate tabeli OrgUnitHierarchyExport

Definicja kolumny InsertDate tabeli OrgUnitHierarchyExport

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

Yes

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna StatusID tabeli OrgUnitHierarchyExport

Definicja kolumny StatusID tabeli OrgUnitHierarchyExport

Name

StatusID

Code

StatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Lista kluczy tabeli OrgUnitHierarchyExport

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli OrgUnitHierarchyExport

Definicja klucza Identifier_1 tabeli OrgUnitHierarchyExport

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment